Contract Business Planning Assistant

Finance Farmington Hills, Michigan


Description

Position at Sumitomo Electric Wiring Systems, Inc.

Job Title: Contract Business Planning Assistant 
 
  • This is a non-exempt Contract position (40 hours per week) through a Staffing Agency, paid hourly, and eligible for additional hours as necessary.
  • This is a Hybrid position, which combines both in office and off-site work.  Associates are required to work at least three days in our Farmington Hills, Michigan office each week, but also have the flexibility to work off-site.  No relocation benefit will be offered for this position.  
 
Basic Purpose:
 
Support collection and review of documentation related to SEWS tariff recovery claims to customers.  Claims are prepared and submitted to customers on a monthly basis. 

 

Job Responsibilities:
 
  1.  Search for required documents (CBP forms and invoices) in shared folders and work with team members to locate missing documents.
  2.  Review documents and confirm details align with recovery claims.
  3.  Update Excel templates (using Vlookups and Pivot Tables) to populate import data into customer required formats.
  4.  Prepare summaries of claims submitted and track recoveries (using Excel).
  
Qualifications:
  • Advanced Excel Skills, including capability to use advanced functions like Vlookups and Pivot Table.
  • Strong analytical and communication skills
  • High School Diploma/GED required.
 
About Sumitomo Electric Wiring Systems, Inc.
Sumitomo Electric Wiring Systems, Inc. (SEWS) is part of the Sumitomo family of companies, a 400 year old brand with a reputation for quality and reliability.  With the support of facilities throughout North America, SEWS has been delivering innovative solutions to automakers for over 30 years, and is a leading supplier of electrical distribution systems, components and electronics.  SEWS is committed to technical development worldwide and with a global network of resources, is able to deliver a truly competitive advantage to each of our customers.  Our associates are what drive Sumitomo’s continued growth, which is why we proudly offer a competitive salary and comprehensive benefits package, including Medical, Dental, Vision, Disability, Life, 401(k) with match, tuition benefits, paid holidays and vacation. 
 
To learn more about us, please visit www.sewsus.com.  

About the Sumitomo Electric Group
Since the founding of Sumitomo Electric Industries, Ltd. in 1897 with copper wire production, we have developed many new technologies and products through innovative R&D activities based on Sumitomo Electric manufacturing technologies for electric wires and power cables.  With more than 350 subsidiaries worldwide, we continue to introduce a wide variety of products that fulfill the expectations of society, in five business fields: Automotive, Information & Communications, Electronics, Environment & Energy, and Industrial Materials.  We are a Fortune global 500 company.   
 
To learn more about Sumitomo Electric Group, please visit http://global-sei.com.  

**Interested Candidates Should Submit Cover Letter and Salary History When Applying.**   
 
An Equal Opportunity Employer M/F/D/